﻿CREATE TABLE [dbo].[TravelDate] (
    [Id]                    UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [TravelAuthorizationId] UNIQUEIDENTIFIER NOT NULL,
    [TravelDate]            DATE             NULL,
    [Destination]           NVARCHAR (250)   NULL,
    [Flights]               INT              NULL,
    [DailyPDRate]           MONEY            NULL,
    [TotalAllowance]        MONEY            NULL,
    [AdvanceRequired]       MONEY            NULL,
    [CurrencyId]            UNIQUEIDENTIFIER NULL,
    [BudgetLineId]          UNIQUEIDENTIFIER NULL
);

